/*
//DG's starting template for Coal Divestment policy coding.

Variables we will use to start in the policy definitions:
(numbers in paranthesis indicates number of banks using this criteria)

	isProjFin: 	  				= 1 for project finance
	isCorpFin:	  				= 1 for corporate finance (3)
	ContinentParent:			{Africa, Asia, Europe, North America, South America, Australia} 
	CountryParent:				{any country name} Update: 9/15/2021 
	
	CoalFracRevParent:			= fraction of revenue from coal of parent company
	CoalSharePowerParent: 		= coal share of power production of parent company

	isMiningCo:					= is company a mining company
	isPowerCo:					= is company a power company
	isMiningProj:				= is project a mining project
	isPowerProj:				= is project a power project

	isNewCustomer				= is the borrower a new customer?

	isLignite:					= is the project using lignite coal?
	isThermal:					= is the project using thermal coal?

	isExpansion:				= are proceeds used for expansion of capacity/life of coal assets?
	isNew:						= are proceeds used for new coal ASSETS?
	isLowCarbonProj:			= are proceeds used for carbon transition / low carbon project
	isMountaintopProj:			= are proceeds used for mountaintop mining?
	isMountaintopComp:			= is company doing mountaintop mining? (6)

	hasDecarbonStrat:			= Company has plan to decarbonize/diversify from carbon
	
	year:						= when is the financing happening
	
	CountryGroup				= Option for group of countries in some
								  policies eg: OECD		
*/

* POLICY 1: XX BANK, YY YEAR
*			local path to pdf of policy document
// use "temp", clear 
// gen CountryGroup = " "
//


***ABN AMRO
* Policy Effective Date:
* PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\ABN_AMRO_Exclusion_list.pdf
gen ban_15000 = 1 if (year >= 2016 & ((isNew==1 & (isMiningProj==1 | isPowerProj==1)) | isMountaintopProj==1)) 

** ABSA*
* Policy Effective Date:
* PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\ABSA_coal-financing-standard.pdf
gen ban_50 = 1 if (year >= 2020 & isNew == 1 & isPowerProj == 1) 
*carveouts if no reasonable cost alternative exists or if project is compliant with Equator Principles (EP)

** ANZ*
* Policy Effective Date:
* PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\ANZ_2020.pdf 
gen ban_967 = 1 if ((year >= 2030 & isHighCarbonProj==1) | /// after 2030, all direct finance only for low carbon projects 
					(year >= 2020 & ((isNewCustomer==1 & CoalFracRevParent > 0.1) |	   		/// after 2020, no new customers with material thermal coal exposures
					(isNew==1 | isExpansion==1))) | ///  after 2020, no direct financing of new or expansion coal power or mining 
					(year >= 2018 & ((isMiningProj==1 & isNew==1) |		///no financing for new conventional coal-fired power stations
					(CoalFracRevParent > 0.5))))
			   
***** Bank of America*
gen ban_1869 = 1 if (((year >= 2021 & ((isPowerProj==1 & (isNew==1 | isExpansion==1) & isHighCarbonProj==1) | /// Ban construction or expansion of new coal fired powerplants - unless they have a low carbon project.
				(isMiningProj==1 & (isNew==1 | isExpansion==1)) | 								/// Ban new coal mines or expansion of existing coal mines
				(isMountaintopComp==1))) | ///
				(year >= 2025 & (isThermal==1 & isMiningCo==1 & CoalFracRevParent>0.25 & hasNoDecarbonStrat==1)))) // Starting 2025 will ban clients having more than 25% of revenue from thermal mining that do not have decarbonization strategy
	
**** Barclays*
gen ban_2263 = 1 if (((year >= 2019 & (isProjFin==1 & isPowerProj==1 & (isNew==1 | isExpansion==1) | /// No project finance to enable the construction or material expansion of coal-fired power stations anywhere in the world  
				(isProjFin==1 & isMiningProj==1 & isThermal==1 & (isNew==1 | isExpansion==1)) | ///No project finance for the development of thermal coal mines anywhere in the world.
				(isMountaintopProj==1))) | ///
				(year>= 2020 & (isThermal==1 & (isMiningCo==1 | isPowerCo==1) & (CoalFracRevParent >0.5))) | ///From 2020 no financing to clients that generate more than 50% of revenue from thermal coal activities
				(year >= 2025 & (isThermal==1 & (isMiningCo==1 | isPowerCo==1) & (CoalFracRevParent >0.3))) | /// 2025, no longer provide any financing to clients that generate more than 30% of revenue from thermal coal activities
				(year >= 2030 & (isThermal==1 & (isMiningCo==1 | isPowerCo==1) & (CoalFracRevParent >0.1))))) //From 2020 no financing to clients that generate more than 10% of revenue from thermal coal activities



**** BAYERN LB*
* PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\Bayern_LB_sustainability_policy_2018.pdf
gen ban_2311 = 1 if (year >= 2018 & (isMountaintopProj==1 )) //| isLignite==1))) 
* emphasis on banning lignite mining + power plants


**** BBVA*
* PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\BBVA_Responsible_banking_2019.pdf
gen ban_1043 = 1 if ((year >= 2019 & ((isNew==1 & (isMiningProj ==1 | isPowerProj==1 | isMountaintopProj==1)) |		/// No new Coal mines, New coal powerplants, New Montaintop removal projects.
				(isExpansion==1 & (isMiningProj==1 | isPowerProj==1)) |			                        /// No mine , powerplant expansions.
				(isMiningCo==1 & CoalFracRevParent >0.35 & hasNoDecarbonStrat==1) |                     /// Excluding clients with >35% revenue from mining without diversifivation strategy
				(isPowerCo==1 & CoalFracRevParent>0.35 & hasNoDecarbonStrat==1))) | /// Excluding clients with >35% revenue from coal power without diversifivation strategy
				(year >= 2018 & ((isNew==1 & (isPowerProj==1 | isMiningProj==1)) | /// would not finance any new coal mines and coal-fired power stations or extensions to existing ones
				((isMiningCo==1 | isPowerCo==1) & CoalSharePowerParent>= 0.4)))) // would exclude companies relying on coal for more than 40 per cent of their mining or power generation activity.     

**** Bendingo and Adelaide bank*
gen ban_2351 = 1 if ((year >= 2014 & (isMiningCo==1 | isPowerCo==1))) // Do not lend to projects in the coal sector


**** BNP Paribas *
gen ban_1106 =1 if ((year > 2020 & (((isNew==1 | isExpansion==1) & isPowerProj==1) | /// No finance for new or expansion of power projects
			  (isNewCustomer==1 & CoalFracRevParent> 0.25 & hasNoDecarbonStrat==1))) | /// No finance for new customers with more than 25% of revenue from mining and has no Diversification strat
			  (year >=2017 & ((isNew==1 & isPowerProj==1) | ///
			  (isPowerCo==1 & isExpansion == 1)))) 
			
***** BPCE*
gen ban_1124 = 1 if (((year> 2015 & (isThermal==1 & isProjFin==1)) | ///
			   (year > 2019 & (isThermal==1 & ((isMiningCo==1 | isPowerCo==1) & CoalFracRevParent >0.25))))) | ///
			   (year>=2020 & (isNew==1 &(isPowerCo==1 | isMiningCo==1))) // Natixis will halt its relationships with clients that develop new capacity in coal-powered electricity generation or thermal coal mining. (PROBLEM)

***** Caixabank* Talk about credit risk
gen ban_2869 = 1 if ((year >= 2019 & ((isMiningProj==1 & (isNew==1 | isExpansion==1)) | ///No credit risk in new or expansion of mining projects 
			   (isMountaintopProj==1) | 									/// No credit risk for Montaintop Removal Projects
			   (isMiningCo==1 & CoalFracRevParent > 0.4 & hasNoDecarbonStrat==1) | ///no credit risk in new long-term transactions or arrangements requested by mining companies with over 40% revenue from coal mining and no diversification strategy.  
			   (isPowerProj==1 & (isExpansion==1 | isNew==1)) |                ///No credit risk in new or expansion of power projects  
			   (isPowerCo==1 & CoalFracRevParent> 0.4 & hasNoDecarbonStrat==1)))) //no credit risk in new long-term transactions or arrangements requested by coal-power companies with over 40% revenue from coal mining and no diversification strategy.

** CATHAY FINANCIAL ????

**** Chiba bank* - 
gen ban_3388 = 1 if (year >= 2020 & (isNew==1 & isPowerProj==1)) // if the support of the Government of Japan, international development organizations, etc. can be confirmed then will consider financing. 


**** CIMB* 
gen ban_2737 = 1 if ((year > 2020 & ((isNew==1 & (isMiningProj==1 | isPowerProj==1) & hasNoDecarbonStrat==1) | /// No financing for new mining or powerprojects that do not have a decarbon strategy 
				(isExpansion==1 & (isMiningProj==1 | isPowerProj==1))))) // No financing for expansion of mining or powerprojects that do not have a decarbon strategy 


** Citi*
gen ban_3536 = 1 if ((year >= 2021 & (( isThermal==1 & isProjFin==1 & (isNew==1|isExpansion==1) & isMiningProj==1) | /// New thermal coal mines or significant expansion of existing mines;
					 (isProjFin==1 & (isNew==1|isExpansion==1) & isPowerProj==1) | ///New coal-fired power plants or expansion of existing plants
					 (isMiningCo==1 & isThermal==1 & CoalFracRevParent >= 0.25) | ///targets to phase out our financing of mining companies deriving ≥25% of their revenue from thermal coal mining
					 (isPowerCo==1 & isHighCarbonProj == 1) | ///
					 (isNewCustomer==1 & (CoalSharePowerParent >= .2 & isHighCarbonProj==1) | ///Not onboard any new clients with ≥20%,
					 (isNewCustomer==1 & isExpansion==1)))) | /// Not onboard any new clients that have plans to expand coal-fired power generation
					 (year > 2025  & ((isPowerCo & CoalFracRevParent >= 0.05 & isNewCustomer == 1) | ///
					 (isMiningCo & isCorpFin))) | ///
					 (year > 2030 & ((isPowerCo & CoalFracRevParent>= 0.05 & CountryGroup == "OECD") | ///
					 (isMiningCo))) | ///
					 (year >=2015 & isMiningCo==1 & CoalFracRevParent >= 0.5))
					


***** Commerzbank*
gen ban_3731 = 1 if (((year >= 2020 & ((isNew ==1 & (isMiningProj==1 | isPowerProj==1)) | ///No financing for new mining projects
				(isMountaintopComp==1))) | ///No Financing for mountaintop companies
				(year>2021 & ((isPowerCo==1 & CoalSharePowerParent > 0.30 & CountryParent == "Germany") | ///German clients from the energy supply sector to limit the share of electricity generated from coal (based on their production performance) to below 30 per cent bythe end of 2021
				(isPowerCo==1 & CoalSharePowerParent>0.5))) | /// For ROW 
				(year > 2016 & ((isNewCustomer==1 & isPowerCo==1 & CoalSharePowerParent> 0.3 & CountryParent == "Germany") | /// For new clients, the above is enacted since 2016
				(isNewCustomer==1 & isPowerCo==1 & CoalSharePowerParent>0.5)))))
		

*** CommonwealthBank
* No defined criteria for exclusions


**** Concordia- Unknown year and Synthetic_Bank_ID
// gen ban = 1 if (isNew==1 & isPowerProj==1 & isHighCarbonProj==1) 


**** CPEG, documents in french. No loans in our datasets

**** Credit Agricole*
gen ban_981 =1 if  ( ///
					(year >= 2020 & ((isNewCustomer==1 & isMiningCo==1 & isThermal==1 & CoalFracRevParent> 0.25==1 & hasNoDecarbonStrat==1) | /// Will not develop relations with companies that generate more than 25% of their turnover in the thermal coal industry and have not adopted a transition strategy  
			   						 (isNewCustomer==1 & isThermal==1 & isPowerCo==1 & (isNew==1 | isExpansion==1)) |  /// the Bank will not enter into relationships with companies developing or planning to develop new thermal coal capacities 
			   						 (isPowerProj==1 & (isNew==1 | isExpansion==1)) | ///No finance for new or exapnding power plants
			    					 (isThermal==1 & (isMiningCo==1 & CoalFracRevParent >0.25) & hasNoDecarbonStrat==1) | ///issuers generating more than 25% of their turnover from thermal coal extraction are divested
									 (  (  (isMiningCo==1 & CoalFracRevParent >0.5) | (isPowerCo==1 & CoalFracRevParent>0.5)) & hasNoDecarbonStrat==1)) ///
					) ///
					| ///issuers generating more than 50% of their turnover from coal sector are divested 
					(year >= 2019 & ((isNewCustomer==1 & CoalFracRevParent>0.25) | ///Credit Agricole will also exclude new clients with more than 25% activity in the coal sector, and will only support existing clients above this threshold with dedicated project financing to non-coal projects
									 (isExpansion==1)) ///
					) ///
					| ///Credit Agricole also ends all supports to companies expanding or planning to expand their activities in the coal sector, from coal extraction to coal power production
					(year > 2016 & ((isNew==1 | isExpansion==1) & isPowerProj==1) ///
					) ///
				   ) ///

*/

**** Credit Mutuel*
*PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\Credit_Mutuel_2020.pdf
gen ban_2726 = 1 if (year >=2020 & ((isExpansion==1 & (isMiningProj==1 | isPowerProj==1)) | /// Banning any company expanding activities in the coal sector
			   ((isMiningCo==1|isPowerCo==1) & CoalFracRevParent>0.20) | 						/// Banning company with coal revenue >20% 
			   ((isPowerCo==1|isMiningCo==1) & CoalSharePowerParent > 0.20) | 					/// Banning company with coal's energy mix > 20%
			   (hasNoDecarbonStrat==1))) | 										/// Continue financing for clients that do have a Diversification Strategy 
				(year >= 2019 & ((isNew==1 & isPowerProj==1) | ///Crédit Mutuel Alliance Fédérale states that it intends to refrain from participating in operations related to the building of new coal-fired power plant
				(CoalFracRevParent >= 0.5 & (isMiningCo==1 | isPowerCo==1)) | ///refrain from entering into relations with companies whose main activity consists in coal mining or is over 50% related to coal sector activities
				(isHighCarbonProj == 1)))	
				
***** Credit_Suisse*
gen ban_3966 = 1 if (((year > 2016 & (isMountaintopProj==1)) | /// No finances for Mountaintop Projects 
				(year>2017 & ((isThermal==1 & isNew==1 & isMiningProj==1) | /// No financing for new thermal mines
				(isPowerProj==1 & isNew==1 & isHighCarbonProj==1))) | /// No financing for new coal power plants unless low carbon technology used
				(year >= 2020 & ((isMiningCo==1 & CoalFracRevParent>0.25 & isThermal==1 & hasNoDecarbonStrat==1) | /// No financing for thermal mining companies having more than 25% of revenue from coal and does not have a diversification strat -- date from yann louvel excel file
				(isPowerCo==1 & CoalFracRevParent>0.25 & hasNoDecarbonStrat==1 ))))) // No financing for Coal Power plant companies having more than 25% of revenue from coal and does not have a diversification strat.

*** Dai_ichi Life *
gen ban_4128 = 1 if ((year > 2019 & (isPowerProj==1))) // general excercise to refrain from lending financial support to coal power projects


**** Danske Bank*
gen ban_4176 = 1 if ((year >2021 & ((isThermal==1 & isMiningCo==1 & CoalFracRevParent > 0.05) |  /// No financing for thermal coal mines with revenue > 0.05
			   (isPowerCo==1 & CoalFracRevParent> 0.05)))) //No financing for coal power companies with revenue > 0.05
		
**** DBS*
gen ban_4309 =1 if ((year > 2020 & ((isNew==1 & isPowerProj==1) | /// No financing on new coal-fired power plants
			  (hasNoDecarbonStrat==1) | /// Only support customers with a diversification strategy
			  (isNew==1 & isProjFin==1 & isThermal==1 & isMiningProj==1) | /// Stopping project financing of greenfield thermal coal mines
			  (isThermal==1 & isMiningCo==1 & CoalFracRevParent == 1.00)))) // Stopping financing of pure play thermal coal mining, processing, trading, construction and operation of thermal coal power plants 

**** Deka* 
gen ban_4229 = 1 if ((year > 2019 & ((isNew==1 | isExpansion==1) & isPowerProj==1))) // Development, construction and operation of coal-fired power plants

**** Desjardins*
gen ban_2683 = 1 if ((year > 2020 & ((isMiningCo==1) | /// Operate or develop coal mines
			   (isPowerCo ==1 & CoalSharePowerParent>0.1) | /// Have greater than 10%, or 5 GW, installed coal power generation capacity
			   ((isNew==1 | isExpansion==1) & isPowerCo==1)))) // Are building, extending or renovating coal mines, power plants or infrastructure.
			   
**** Deutsche Bank*
gen ban_4293 = 1 if (((year > 2016 & (isPowerProj==1 & (isNew==1 | isExpansion==1))) | ///
			   (year > 2020 & ((isMountaintopProj==1 & CountryParent == "USA") | /// No financing for MTR projects in the USA
			   (isPowerCo==1 & CoalFracRevParent > 0.5 & hasNoDecarbonStrat==1 & ContinentParent != "Asia") | /// Not provide finances for companies with more than 50% revenue and not have decarbonization strategy. 2020 for all continents except for Asia.
			   (isMiningProj==1 & isThermal==1 & isNew==1)))  | ///not provide any financing for greenfield thermal coal mining
			   (year>=2022 & isPowerCo==1 & CoalFracRevParent > 0.5 & hasNoDecarbonStrat==1 & ContinentParent == "Asia"))) // 2022 for asia

**** DNB*
gen ban_4100 = 1 if ((year > 2016 & ((isProjFin==1 & isPowerProj==1) | /// No project Finance for coal fired power plant
				(isNew==1 & isPowerCo==1 & CoalFracRevParent > 0.3)))) // New customers with more than 30% share of rev from coal fired power plants
											
***** DZ Bank*
gen ban_4107 = 1 if (((year > 2017 & (isProjFin==1 & isPowerProj==1)) | ///
			   (year > 2020 & ((isPowerProj==1 & (isNew==1 | isExpansion==1)) | ///No financing of new or existing coal-fired power plants
			   (isMiningCo==1 & isThermal==1) |  ///No financing of activities upstream in the value chain for thermal coal, especially mining, trade and directly related activities
			   (hasNoDecarbonStrat==1))))) // No indirect financing of companies with an increased share of coal if no will to transform is evident or if the use of funds for coal can be ruled out
			   
**** E.Sun*
gen ban_4462 = 1 if ((year > 2019 & (isPowerProj==1 & (isNew==1 | isExpansion==1))))


**** Erste Group*
gen ban_1261 = 1 if (((year >= 2021 & ((isMiningProj==1 |isPowerProj==1) & (isNew==1 | isExpansion==1) | ///Direct financing of coal-asset specific investments or cash flows related to coal mining, coal processing, coke processing or coal based power generation
			(isCorpFin==1 & isExpansion==1 & (isMiningCo==1 | isPowerCo==1)) | /// Corporate financing for companies or group of companies which extend their coal mining or coalbased power generation (installed) capacities
			(isCorpFin==1 & ((isMiningCo==1 & CoalFracRevParent>0.25 ) | (isPowerCo==1 & CoalFracRevParent>0.25))))) |  ///Corporate financing for companies or group of companies which have more than 25% of revenues coming from coal sector
			(year > 2023 & hasNoDecarbonStrat==1 & isCorpFin==1))) //Corporate financing for companies or group of companies which do not set up until end of 2023 a transition plan aligned with the 2030 phase out target

**** Goldman Sachs* -- Date from Yann louvel reclaim finance
* PATH TO POLICY PDF: \Dropbox\coal_finance\Divestment docs\Goldman_Sachs_2020.pdf
gen ban_5853 = 1 if ((year > 2019 & ((isNew==1 & isPowerProj==1 & isHighCarbonProj==1) | /// No financing for new coal power plants that do not have low carbon policies
				(isNew==1 & isMiningProj==1) | 									/// No financing for new thermal coal mine
				((isNew==1 | isExpansion==1) & isMountaintopProj==1))))  				// No Financing for MTR projects 
  
**** Handelsbanken* 
gen ban_6253 = 1 if ((year > 2019 & ((isMiningProj==1 | isPowerCo==1) & (isNew==1 | isExpansion==1) | /// No financing for new or developing Coal power plants or mines
			   (isNewCustomer==1 & !hasNoDecarbonStrat==1)))) // Not deelop relations with clients active in coal sector and do not have a transition policy
	
**** Hannoversche Beteiligungsgesellschaft- Synthetic_Bank_ID not known. No transactions.
//gen ban_XX = 1 if ((year > 2019 & (isPowerProj))) ///Financing the construction of conventional coal-fired power plants.

	   
****HSBC* 
gen ban_6184 = 1 if (((year >= 2020 & (((isNew==1 |isExpansion==1) & isMiningProj==1) | 		/// No Financing for New or expansion of existing mining projects
			(isNewCustomer==1 & isMiningCo==1 & CoalFracRevParent > 0.5) | 		/// Not take any new customers dependent (>50% of coal revenue) from coal
			(isMountaintopComp==1 & CountryParent == "USA") | 					/// No finance for MTR firms in the USA
			(isMountaintopProj==1 & isMiningProj==1) | 							/// No finance for Mountaintop mines 
			((isNew==1 | isExpansion==1) & isPowerProj==1 & isHighCarbonProj==1))) | ///
			(year >=2018 & (isNew==1 & isPowerProj==1 & (CountryParent != "Bangladesh" | CountryParent != "Indonesia" | CountryParent != "Vietnam")))))		 // Banning finance for new or expanding power plants without a low carbon policy
	
*** ING*
gen ban_6757 = 1 if (((year >= 2019 & ((isNew==1 &(isMiningProj==1 | isPowerProj==1)) |								/// No financing for new thermal coal power or coal mines
			(isNewCustomer==1 & (hasNoDecarbonStrat == 1 | CoalSharePowerParent> 0.1)))) | 				/// Ban new customers with sahre of power > 10%. Should also have a strat to reduce 5%
			(year >= 2025 & isPowerCo==1 & CoalFracRevParent > 0.05 ) | /// Ban Finance for all clients with coal revenue fraction less than 5%BY 2025 (How to code expectation of lower fraction in future?)
			(year > 2017 & CoalFracRevParent >0.1 & hasNoDecarbonStrat==1) | ///
			(year > 2015 & (isNew==1 & (isPowerProj==1 | (isThermal==1 & isMiningProj==1)) | ///
			(isNewCustomer==1 & CoalFracRevParent > 0.5))))) 										
		   
**** Intessa San Paolo* --- Date from Yann louvel excel file 
gen ban_1317 = 1 if ((year >= 2020 & ((isNew==1 & isMiningProj==1) | ///
			   (isMiningCo==1 & isMountaintopComp==1) | ///
			   isPowerCo==1 & ((CoalSharePowerParent > 0.5 & CountryGroup == "Non-OECD") | (CoalSharePowerParent > 0.3 & CountryGroup == "OECD")))))

			   
**** Investec* 
gen ban_7072 = 1 if ((year >=2020 & ((isMountaintopProj==1) | ///We will not finance mountaintop removal mining activities
			   (isPowerProj==1 & isHighCarbonProj==1) |   ///Investec will not provide funding to new build of conventional plants*.
			   (isExpansion==1 & hasNoDecarbonStrat==1))))   // not for expansion purposes unless it meets the required efficiency criteria  

**** JPMorgan*
gen ban_6179 = 1 if ((year >=2020 & ((isProjFin==1 & isNew==1 & isMiningProj==1) | /// No Project finance to develop new mines
			   (isMiningCo==1 & CoalFracRevParent > .5) | ///Not provide lending, capital markets or advisory services to companies deriving the majority of their revenues from the extraction of coal
			   (isMiningProj==1) | /// NO mountaintop projects
			   (isPowerProj==1 & isProjFin==1 & isHighCarbonProj==1)))) | ///not provide project financing or other forms of asset-specific financing where the proceeds will be used to develop a new coal-fired power plant or refinance an existing coal-fired power plant
			   ((year >= 2024 & isCorpFin == 1 & isMiningCo))
			   
			   
**** KB Financial* -- Date from Yann louvel excel file
gen ban_7434 = 1 if ((year >2020 & (isProjFin==1 & isPowerProj==1 & isNew==1))) // Suspension of new project financing and bond underwriting for domestic and overseas coal-fired power plant construction

***** KBC* 
gen ban_7439 = 1 if (((year > 2016 & ((isNew==1 & (isMiningProj==1 | isPowerProj==1)) | ///
			   (CountryParent == "Czech Republic" & isHighCarbonProj==1) | ///
			   ((isPowerCo==1|isMiningCo==1) & CoalFracRevParent>0.5))) |                                 /// "2016 - No direct finance for coal mining and coal power projects worldwide, with an exception for Czech Republic. Exclusion of companies generating over 50% of their turnover from coal power."
			   (year > 2018 & (((isPowerCo==1|isMiningCo==1) & CoalFracRevParent> 0.25) |				  /// "2018 - reduced to 25% and no finance without transition strat "
			   (hasNoDecarbonStrat==1))) | ///
			   (year >= 2020 & ((isNewCustomer==1 & isPowerCo==1 & CoalFracRevParent >= 0)))))  // "2020 - No new customer with any stake in coal"

**** Kiwibank*
gen ban_9432 = 1 if (year >= 2020 & (isMiningCo==1)) // banking services to entities that are directly involved in, or where the majority of their business revenue is from

** LBBW??

**** Lloyds Banking Group*
gen ban_8286 =1 if ((year >= 2019 & ((isNew==1 & isPowerProj==1) | ///
			   (isThermal==1 & isNew==1 & isMiningProj==1) | ///
			   (isNewCustomer==1 & ((isMiningCo==1|isPowerCo==1) & CoalFracRevParent > 0.5)))))	// The Bank will not bank new clients where most of their revenue is  derived from coal-fired power stations or thermal coal mines		   
		

**** mBank*
gen ban_13818 = 1 if ((year>=2019 & (isNew==1 & (isMiningProj==1 | isPowerProj==1) | /// No financing for New mining or power projects
				(isNewCustomer==1 & CoalSharePowerParent > 0.5)))) // Not engage with new clients with more than 50% in power generation capacity from coal
				

**** Mizuho* -- Date from Yann louvel excel file 
gen ban_8939 = 1 if (((year >= 2020 & ((isNewCustomer==1 & (isNew==1 | isExpansion==1) & isPowerProj==1) | /// No financing for new customers for new powerprojects
			   (isMountaintopProj==1))) | /// No financing for Mountaintop projects
			   (year >= 2021 & (isNew==1 | isExpansion==1) & isPowerProj==1)))

**** Morgan Stanley*
gen ban_9031 = 1 if ((year >2020 & ((isPowerProj==1 & (isNew==1 | isExpansion==1) & isHighCarbonProj==1) | ///We will not finance transactions globally that directly support the development of new or physical expansions of coal-fired power generation
					 (isMountaintopProj==1 & isMiningCo ==1) | ///
					 (isNew==1 & isThermal==1 & isMiningProj == 1))))

***** MUFG*
gen ban_8917 = 1 if ((year >= 2020 & ((isNew==1 & isPowerProj==1) | ///MUFG will not provide financing to new coal fired power generation project
			   (isMountaintopProj==1)))) //We will not provide any financing to coal mining projects using the mountaintop removal
			   
**** NAB* 
gen ban_9227 = 1 if ((year > 2017 & (isNew==1 & isThermal==1 & isMiningProj==1)) | /// No new thermal coal mines
			   (year > 2019 & ((isThermal==1 & isNewCustomer==1 & isMiningProj==1) | /// New thermal coal mining projects or new-to-bank thermal coal mining customers.
			   (isPowerProj==1 & (isNew==1 | isExpansion==1) & isHighCarbonProj == 1 )))) // NAB will not finance new or material expansions of coal-fired power generation facilities unless there is technology in place to materially reduce emissions.

***** Natwest* 
gen ban_11026 = 1 if (((year >= 2018 & ((isNew==1 & isPowerProj==1) | 							///New coal fired power stations
				(isThermal==1 & isMiningProj==1 & isNew==1) |						 	///New thermal coal mines
				(isMiningCo==1 & isThermal==1 & CoalFracRevParent > 0.4) | 			///Mining companies generating more than 40% of their revenues from thermal coal
				(isPowerCo==1 & CoalSharePowerParent>0.4))) | 						/// Power companies generating more than 40% of their electricity from coal		   
				(year > 2021 & ((isMiningCo==1 & CoalFracRevParent>0.15) | (isPowerCo==1 & CoalFracRevParent>0.15))) | /// Stop lending and underwriting to companies with >15% of activitiesrelated to thermal and lignite coal
				(year > 2021 & (hasNoDecarbonStrat==1)))) 							// Stop lending without a transition.

**** NBS* -- Date taken from Yann Louvel reclaim finance
gen ban_9374 = 1 if ((year >= 2019 & ((isPowerProj==1 & isNew==1) | ///Not provide financing to any new coal-fired power stations regardless of technology or jurisdiction
			   (isMiningProj==1 & isNew==1 & isThermal==1 & CountryParent != "South Africa") | ///Not provide financing to thermal coal mines outside of South Africa
			   (isThermal==1 & isMiningCo==1 & CoalFracRevParent > 0.4)))) //Thermal coal mining company relates to mining companies that derive more than 40% of their revenue from thermal coal mining
				
*** Nippon Life* -- Adopted from Yanna Louvel
gen ban_9480 = 1 if ((year > 2018 & (isNew==1 & isPowerProj==1))) // not to engage in new investment and financing in coal-fired power generation projects anywhere in Japan or overseas.

*** Nordea*   ---- QUESTION
gen ban_9527 = 1 if (((year > 2015 & (isNewCustomer==1 & (CoalFracRevParent == 1 | CoalSharePowerParent == 1))) | ///not to start new customer relationships with companies primarily dependent on coal
				(year > 2020 &((isThermal==1 & isNewCustomer==1 & ((isMiningCo==1 & CoalFracRevParent > 0.5) | (isPowerCo==1 & CoalSharePowerParent > 0.5))) | ///not start any new banking relationships with companies that are pre-dominantly dependent on thermal coal, including coal-fred energy production and/or mining companies
				(hasNoDecarbonStrat==1) | ///
				((isPowerCo==1 & CoalFracRevParent > 0.3) | (isMiningCo==1 & CoalFracRevParent > 0.3)))))) // does not invest in companies that have large and sustained exposure to thermal coal mining and more than 30%of their revenues derived from sales of coal products

**** Norinchukin*
gen ban_9543 =1 if(( year > 2019 & (isPowerProj==1 & isNew==1))) // NO financing for new power projects


**** OCBC*
gen ban_9943 = 1 if ((year >= 2019 & (isPowerProj==1 & isNew==1))) // NO financing for new power projects

***PKO BP* 
gen ban_10009 = 1 if ((year >= 2019 & (isMiningProj==1 & isNew==1))) // NO financing for new mining projects

***PNC* -- Date taken from Yann louvel 
gen ban_10016 = 1 if ((year > 2017 & (isNewCustomer==1))) // How to do this---->more than a de minimis exposure to mountaintop removal mining?

***Rabobank* -- Date taken from yann louvel excel file
gen ban_10773 = 1 if ((year >= 2017 & (isPowerCo==1 | isMiningCo==1)))
/*
• directly finance the exploration, extraction or production of coal used for
power generation, shale gas, tar sands and other nonconventional fossil
natural resources, nor the transport up to the production unit, production,
processing, or refining of these extractive industries products;
• directly finance coal-fired power generation;
• directly finance the trade of coal for power generation. We may directly
finance the trade of higher grade metallurgical coals used for the
production of steel and base metals only;
• finance companies that realize more than 20% of their turnover in trading
coal used for power generation.
*/

***Raiffeisen*
gen ban_10781 = 1 if ((year >= 2019 & ((isNew==1 & isThermal==1 & isMiningProj==1) | ///
				(isNewCustomer==1 & isThermal==1 & isMiningCo==1)| ///
				(isThermal==1 & isMiningCo==1)))) //customers in the thermal coal mining sector or companies where more than 50 percent of the revenue is generated from thermal coal trading.

***RBC*
gen ban_10727 = 1 if ((year > 2020 & ((isNew==1 & isThermal==1 & isMiningProj==1) | ///
				(isMountaintopProj==1) | /// new greenfield coal-fired power plant, thermal coal mine or Mountain Top Removal coal mining projects.
				(isNewCustomer==1 & ((isThermal==1 & isMiningCo==1 & CoalFracRevParent > 0.6) | (isPowerCo==1 & CoalSharePowerParent> 0.6)) & hasNoDecarbonStrat==1))))				//will not provide financing to new clients that operate significant thermal coal mining (>60% revenue) or coal power generation assets (>60% generation, Megawatt hour (MwH).
			 
				
***Resona Holdings*
gen ban_10909 = 1 if ((year >= 2019 & ((isProjFin==1 & isNew==1 & isThermal==1 & isPowerProj==1))))

***Rothschild & co*
gen ban_9146 = 1 if ((year >= 2020 & ((isThermal==1) | ///
				(isThermal==1 & isMiningProj==1 & isNew==1)| ///
				(isNew==1 & isPowerProj==1)))) // not provide financing or financing advisory in relation to new thermal coal mining projects, new thermal coal developments or new coal-fired power generation assets


***Samsung* -- From the Yann Louvel Excel file as link is empty
gen ban_11256 = 1 if ((year > 2020 & isNew==1))

****Santander*
gen ban_1527 = 1 if ((year >= 2020 & ((isNew==1 & isPowerProj==1)| ///New coal-fired Power Plants projects worldwide.
				(isNewCustomer==1 & isPowerCo==1) | ///New clients with coal-fired power plants worldwide.
				(isPowerProj==1 & isHighCarbonProj==1)))) //For existing clients: Transactions specific to coal power plants are allowed only when they improve significantly environmental impacts

****SEB* --- From Yann Louvel Excel File
gen ban_11100 = 1 if ((year > 2015 & ((isNewCustomer==1 & isMiningCo==1 & CoalFracRevParent > 0.5) |  ////Exclusion of companies with major business in coal mining for new clients.
				(isPowerProj==1)))) //Ending financing for coal power projects worldwide.

***Shinhan* -- Exact carbon emission listed, should we use isLowCarbonProj? -- Date from Yann Louvel excel file
gen ban_11616 = 1 if ((year>2020 & isProjFin==1 & isHighCarbonProj==1 & CountryGroup == "OECD"))
 
****Shinsei Bank*
gen ban_11628 = 1 if ((year >= 2020 & ((isThermal==1 & isPowerProj==1)))) //new investment and lending to coal-fired thermal power plants will not be provided either in Japan or overseas, in principle, based on a preventive approach

****Societe Generale*
gen ban_11775 = 1 if (((year > 2015 & ((isProjFin==1 & isMiningProj==1 & (isExpansion ==1 | isNew ==1)) | /// No project financing of development of coal mines
			   (isPowerProj==1 & isProjFin==1 & (isNew==1 | isExpansion==1)) | ///& CountryGroup == "High Income OECD") | ///no longer be involved in project financing of coal-fired power plants in high income OECD countries
			   (isMountaintopComp==1)))  | /// does not offer financial products and services to clients who are involved in Mountain Top Removal 
			   (year >= 2019 & ((isThermal==1 & ((isMiningCo==1 |isPowerCo ==1 & CoalFracRevParent > 0.5)) | /// No financing to the clients whose current activity in thermal coal* represents 50% or more
			   (isThermal==1 & (((isMiningCo==1 | isPowerCo==1) & CoalFracRevParent < 0.5 & CoalFracRevParent> 0.3)) & hasNoDecarbonStrat==1) | /// whose current activity in thermal coal represents between 30% and 50% and do not have a reduction strategy to reach at most 30% by 2025
			   (isExpansion==1 & (isMiningCo==1 | isPowerCo==1))))) | /// who have plans to expand their thermal coal capacities
			   (year >= 2020 & ((isThermal==1 & (isMiningCo==1 | isPowerCo==1)) | ///are Thermal Coal Developing Companies6 or -- 2020 date taken from yann louvel excel file
			   (isThermal==1 & (((isMiningCo==1 & isPowerCo==1) & CoalFracRevParent > 0.25))))) | ///have more than 25% of their revenue linked to the Thermal coal sector7 or
			   (year > 2021 & hasNoDecarbonStrat == 1))) // Does not have a transition plan.
			   
//  Sparkassen- und Giroverband Hessen-Thüringen (Helaba)* 
gen ban_8081  = 1 if ((year > 2020 & ((isPowerProj==1 & (isNew==1 | isExpansion==1)) | ///No financing for projects involving the construction of new coal-fired power plants or for expanding the capacity of existing coal-fired power plants
			   (isNewCustomer==1 & (isMiningCo==1 | isPowerCo==1)) | /// No financing of new corporate clients whose business predominantly involves coal-based energy (coal mining or coal-fired power plants)
			   (isMiningProj==1 & (isNew==1 | isExpansion==1)) | /// No financing of projects directly related to the mining of power plant coal, including process chains directly and exclusively associated
			   (isMountaintopProj==1) | ///No financing of projects in connection with mountaintop removal mining
			   (isPowerCo==1 & CoalFracRevParent>0.25))))
		

***Standard Bank*
gen ban_12090 = 1 if ((year >= 2019 & (isNew==1 & isPowerProj==1 & isHighCarbonProj == 1 ))) //& CountryGroup != "IDA"))) /// IDA - Overseen by 173 shareholder nations, IDA aims to reduce poverty by providing loans (called "credits") and grants for programs that boost economic growth, reduce inequalities, and improve people's living conditions. IDA lends money on concessional terms.

***Standard Chartered* 
gen ban_12093 = 1 if (((year > 2018 & ((isNew==1 & isMiningProj==1 & isThermal==1)| /// New standalone non-captive thermal coal mining projects -- Date taken from Yann louvel
			   ((isNew==1 | isExpansion==1) & isPowerProj==1 & isHighCarbonProj==1) | ///New coal-fired power plant projects in any location; Any coal-fired power plant expansions, retrofits or dedicated infrastructure, in any location
			   (isMountaintopProj==1)))|  /// Mining operations that conduct Appalachian Mountaintop Removal
			   (year >= 2021 & (isThermal==1 & (((isMiningCo==1 |isPowerCo==1) & CoalFracRevParent == 1.00)))) | ///By January 2021, we will have no group level clients who are 100% dependent on earnings from thermal coal
			   (year >= 2025 & (isThermal==1 & (((isMiningCo==1 |isPowerCo==1) & CoalFracRevParent > 0.60)))) | ///By January 2025, we will extend this threshold to group level clients who are greater than 60% dependent on earnings from thermal coal
			   (year >= 2027 & (isThermal==1 & (((isMiningCo==1 |isPowerCo==1) & CoalFracRevParent> 0.40)))) | ///greater than 40% dependent on earnings from thermal coal
			   (year >= 2030 & (isThermal==1 & (((isMiningCo==1 | isPowerCo==1) & CoalFracRevParent > 0.10)))))) // By January 2030, we will extend this threshold to group level clients who are greater than 10% dependent on earnings from thermal coal
			   

****Sumitomo Mitsui Financial Group* -- Date taken from Yann louvel
gen ban_12295 = 1 if ((year >2020 & (((isNew==1 | isExpansion==1) & isPowerProj==1)| ///
			   (isMountaintopProj==1)))) // Support for newly planned coal-fired power plants and the expansion of existing plants are not provided

****Sumitomo Mitsui Trust Holdings* -- Date taken from Yann louvel
gen ban_12296 = 1 if ((year >= 2019 & (isNew==1 & isPowerProj==1) & isProjFin == 1)) // SuMi TRUST Bank has decided, in principle, not to engage in new projects for the construction of coal-fired power plants

***Swedbank*
gen ban_12367 = 1 if ((year > 2018 & ((((isMiningCo==1 | isPowerCo==1) & CoalFracRevParent>0.05))|  /// We will not provide financial services to companies mining and producing coal to more than 5% of its revenue
			    (isNew==1 & isPowerProj==1)))) // We will not directly finance coal-fired power production or the establishment of new coal-fired power plants
				 
*****TD* (unkonwn year WaybackMachine suggests 2017, Page source code says 2020)
gen ban_12752 = 1 if year > 2020 & (isMountaintopProj==1 & isMiningProj==1)

***Toho*
gen ban_12684 = 1 if ((year >= 2020 & (isNew==1 & isPowerProj==1)))

****UBS*
gen ban_12925 = 1 if ((year > 2020 & ((isNew==1 & isPowerProj==1)| ///Not providing project-level finance to new coal-fired power plants globally
		       (isPowerCo==1 & CoalSharePowerParent>0.3 & hasNoDecarbonStrat==1 & isHighCarbonProj==1) | ///Only supporting financing to transactions of existing coal-fired operators (>30% coal reliance)who have a transition strategy in place, or if the transaction is related to renewable energy
			   (isMiningProj==1 & isThermal==1 & (isNew==1 | isExpansion==1))| ///Not providing financing where the stated use of proceeds is for greenfield1 thermal coal mines
			   (isMountaintopComp==1)))) //Not providing financing to coal-mining companies engaged in MTR operations

***Unicredit* 
gen ban_9042 = 1 if ((year > 2020 & ((isProjFin==1) | ///
			   (isExpansion == 1) | /// No Project finance or Expansion finances
			   ((isMiningCo == 1|isPowerCo== 1) & CoalFracRevParent > 0.25 & hasNoDecarbonStrat == 1)))) // No financing for companies above 25% of revenue from coal unless they have a plan to exit by 2030

****United Overseas Bank (UOB)* 
gen ban_13101 = 1 if ((year >= 2019 & ((isNew==1 & isPowerProj==1) | ///
			   (isProjFin==1 & isMiningProj==1 & isNew==1 & isThermal==1)) )) //Discontinued new financing of coal-fired power plant projects and prohibited the project financing of greenfield thermal coal mines

****US Bancorp*
gen ban_12946 = 1 if ((year > 2021 & ((isMountaintopProj==1) | /// No participation in Mountaintop projects
			   (isProjFin==1 & isNew==1 & isMiningProj==1) | /// we will not participate in any relationship involving or provide project financing or other forms of asset-specific financing for the development of new coal mines.
			   (isPowerProj==1 & isProjFin==1 & (isNew==1 | isExpansion==1))))) //direct project financing of coal-fired power plants and relationships that involve constructing such plants.
			   
***Wells Fargo*-- Date from Yann Louvel Excel file 
gen ban_13490 = 1 if( (year > 2015 & (isMountaintopProj==1)))


****Westpac -- Link not found* -- Date from Yann Louvel Excel file 
gen ban_13563 =1 if ((year >= 2017 & ((isThermal==1 & isNew == 1 & isMiningProj==1) | (isPowerProj==1))))
/*
•	Ending direct finance for new thermal coal mines projects in new coal producing basins or where the calorific value is not in the top 15% globally.
•	Exclusion of coal mining companies that have a calorific value which  &does not rank in the top quartile globally.
•	Ending direct finance for new coal power generation where it does not reduce the emissions intensity of the grid in which the generator operates.

***Zurcher Kantonalbank 













